Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 52413 |
| Missing cells | 118346 |
| Missing cells (%) | 14.1% |
| Duplicate rows | 1155 |
| Duplicate rows (%) | 2.2% |
| Total size in memory | 8.8 MiB |
| Average record size in memory | 176.3 B |
Variable types
| Numeric | 14 |
|---|---|
| Categorical | 2 |
13170_FERM0101.DO_2_PV has constant value "0.0" | Constant |
| Dataset has 1155 (2.2%) duplicate rows | Duplicates |
13170_FERM0101.PUMP_1_PV is highly imbalanced (99.8%) | Imbalance |
13170_FERM0101.Agitation_PV has 4461 (8.5%) missing values | Missing |
13170_FERM0101.Air_Sparge_PV has 4461 (8.5%) missing values | Missing |
13170_FERM0101.Biocontainer_Pressure_PV has 4460 (8.5%) missing values | Missing |
13170_FERM0101.DO_1_PV has 4461 (8.5%) missing values | Missing |
13170_FERM0101.DO_2_PV has 50789 (96.9%) missing values | Missing |
13170_FERM0101.Gas_Overlay_PV has 4461 (8.5%) missing values | Missing |
13170_FERM0101.Load_Cell_Net_PV has 4460 (8.5%) missing values | Missing |
13170_FERM0101.pH_1_PV has 5108 (9.7%) missing values | Missing |
13170_FERM0101.pH_2_PV has 4460 (8.5%) missing values | Missing |
13170_FERM0101.PUMP_1_PV has 4461 (8.5%) missing values | Missing |
13170_FERM0101.PUMP_1_TOTAL has 4460 (8.5%) missing values | Missing |
13170_FERM0101.PUMP_2_PV has 4461 (8.5%) missing values | Missing |
13170_FERM0101.PUMP_2_TOTAL has 4460 (8.5%) missing values | Missing |
13170_FERM0101.Single_Use_DO_PV has 4461 (8.5%) missing values | Missing |
13170_FERM0101.Single_Use_pH_PV has 4461 (8.5%) missing values | Missing |
13170_FERM0101.Temperatura_PV has 4461 (8.5%) missing values | Missing |
13170_FERM0101.Agitation_PV has 22712 (43.3%) zeros | Zeros |
13170_FERM0101.Air_Sparge_PV has 44491 (84.9%) zeros | Zeros |
13170_FERM0101.DO_1_PV has 35465 (67.7%) zeros | Zeros |
13170_FERM0101.Gas_Overlay_PV has 16552 (31.6%) zeros | Zeros |
13170_FERM0101.Load_Cell_Net_PV has 952 (1.8%) zeros | Zeros |
13170_FERM0101.PUMP_1_TOTAL has 2802 (5.3%) zeros | Zeros |
13170_FERM0101.PUMP_2_PV has 41361 (78.9%) zeros | Zeros |
13170_FERM0101.PUMP_2_TOTAL has 15718 (30.0%) zeros | Zeros |
Reproduction
| Analysis started | 2024-09-29 18:17:35.655965 |
|---|---|
| Analysis finished | 2024-09-29 18:17:50.457570 |
| Duration | 14.8 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
13170_FERM0101.Agitation_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 779 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 4461 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.692431 |
| Minimum | 0 |
|---|---|
| Maximum | 84 |
| Zeros | 22712 |
| Zeros (%) | 43.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 20 |
| Q3 | 80 |
| 95-th percentile | 80 |
| Maximum | 84 |
| Range | 84 |
| Interquartile range (IQR) | 80 |
Descriptive statistics
| Standard deviation | 34.858793 |
|---|---|
| Coefficient of variation (CV) | 1.173996 |
| Kurtosis | -1.4213791 |
| Mean | 29.692431 |
| Median Absolute Deviation (MAD) | 20 |
| Skewness | 0.62556787 |
| Sum | 1423811.4 |
| Variance | 1215.1355 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 22712 | |
| 80 | 13845 | |
| 20 | 8610 | 16.4% |
| 36 | 645 | 1.2% |
| 40 | 576 | 1.1% |
| 84 | 218 | 0.4% |
| 79.68499756 | 111 | 0.2% |
| 79.67000122 | 93 | 0.2% |
| 79.65499878 | 76 | 0.1% |
| 44 | 65 | 0.1% |
| Other values (769) | 1001 | 1.9% |
| (Missing) | 4461 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 22712 | |
| 20 | 8610 | 16.4% |
| 20.0020768 | 1 | < 0.1% |
| 20.06867879 | 1 | < 0.1% |
| 20.09342888 | 1 | < 0.1% |
| 20.47142792 | 1 | < 0.1% |
| 20.51386088 | 1 | < 0.1% |
| 20.55714264 | 1 | < 0.1% |
| 20.5946035 | 1 | < 0.1% |
| 20.65714264 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 84 | 218 | 0.4% |
| 80 | 13845 | |
| 79.9992932 | 1 | < 0.1% |
| 79.89599753 | 1 | < 0.1% |
| 79.83249055 | 1 | < 0.1% |
| 79.81953964 | 1 | < 0.1% |
| 79.78946928 | 1 | < 0.1% |
| 79.7 | 20 | < 0.1% |
| 79.69697277 | 1 | < 0.1% |
| 79.69690842 | 1 | < 0.1% |
13170_FERM0101.Air_Sparge_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 3462 |
|---|---|
| Distinct (%) | 7.2% |
| Missing | 4461 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9004484 |
| Minimum | 0 |
|---|---|
| Maximum | 160.08291 |
| Zeros | 44491 |
| Zeros (%) | 84.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 23.695022 |
| Maximum | 160.08291 |
| Range | 160.08291 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 12.290201 |
|---|---|
| Coefficient of variation (CV) | 4.2373452 |
| Kurtosis | 20.335335 |
| Mean | 2.9004484 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.4892238 |
| Sum | 139082.3 |
| Variance | 151.04904 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 44491 | |
| 64.15761628 | 1 | < 0.1% |
| 23.072867 | 1 | < 0.1% |
| 19.10034437 | 1 | < 0.1% |
| 29.22128906 | 1 | < 0.1% |
| 43.8859314 | 1 | < 0.1% |
| 1.803031983 | 1 | < 0.1% |
| 62.91697998 | 1 | < 0.1% |
| 13.97447851 | 1 | < 0.1% |
| 35.00180359 | 1 | < 0.1% |
| Other values (3452) | 3452 | 6.6% |
| (Missing) | 4461 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 44491 | |
| 0.002593287407 | 1 | < 0.1% |
| 0.0399603269 | 1 | < 0.1% |
| 0.06761282211 | 1 | < 0.1% |
| 0.06829175277 | 1 | < 0.1% |
| 0.1256828547 | 1 | < 0.1% |
| 0.204037714 | 1 | < 0.1% |
| 0.260233666 | 1 | < 0.1% |
| 0.2726849476 | 1 | < 0.1% |
| 0.4026365064 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 160.0829064 | 1 | |
| 160.0290024 | 1 | |
| 160.0273496 | 1 | |
| 160.0053029 | 1 | |
| 159.9894573 | 1 | |
| 159.9856798 | 1 | |
| 65.14790723 | 1 | |
| 65.1366272 | 1 | |
| 65.07252359 | 1 | |
| 64.9895874 | 1 |
13170_FERM0101.Biocontainer_Pressure_PV
Real number (ℝ)
MISSING
| Distinct | 23622 |
|---|---|
| Distinct (%) | 49.3% |
| Missing | 4460 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 139.79091 |
| Minimum | -5.8685431 |
|---|---|
| Maximum | 480 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 23415 |
| Negative (%) | 44.7% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -5.8685431 |
|---|---|
| 5-th percentile | -2.4183727 |
| Q1 | -1.1364008 |
| median | 0.10706177 |
| Q3 | 480 |
| 95-th percentile | 480 |
| Maximum | 480 |
| Range | 485.86854 |
| Interquartile range (IQR) | 481.1364 |
Descriptive statistics
| Standard deviation | 218.45633 |
|---|---|
| Coefficient of variation (CV) | 1.5627363 |
| Kurtosis | -1.16231 |
| Mean | 139.79091 |
| Median Absolute Deviation (MAD) | 1.5067611 |
| Skewness | 0.9151489 |
| Sum | 6703393.4 |
| Variance | 47723.169 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 480 | 13999 | |
| 0.1678222656 | 244 | 0.5% |
| -0.6828674316 | 223 | 0.4% |
| -0.703125 | 220 | 0.4% |
| -1.3715271 | 219 | 0.4% |
| -0.9259277344 | 208 | 0.4% |
| -1.168981934 | 205 | 0.4% |
| 0.188079834 | 201 | 0.4% |
| 0.1475708008 | 198 | 0.4% |
| -1.148724365 | 196 | 0.4% |
| Other values (23612) | 32040 | |
| (Missing) | 4460 | 8.5% |
| Value | Count | Frequency (%) |
| -5.868543094 | 1 | |
| -5.629517208 | 1 | |
| -5.240161133 | 1 | |
| -5.1996521 | 1 | |
| -5.187527926 | 1 | |
| -5.086044468 | 1 | |
| -5.085721388 | 1 | |
| -5.057867432 | 1 | |
| -5.041116826 | 1 | |
| -5.037615967 | 1 |
| Value | Count | Frequency (%) |
| 480 | 13999 | |
| 66.94743554 | 1 | < 0.1% |
| 51.83739014 | 1 | < 0.1% |
| 14.63064017 | 1 | < 0.1% |
| 10.93886667 | 1 | < 0.1% |
| 10.75693679 | 1 | < 0.1% |
| 10.74510228 | 1 | < 0.1% |
| 10.74074097 | 2 | < 0.1% |
| 10.72358127 | 1 | < 0.1% |
| 10.69196393 | 1 | < 0.1% |
13170_FERM0101.DO_1_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 7705 |
|---|---|
| Distinct (%) | 16.1% |
| Missing | 4461 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.2651856 |
| Minimum | 0 |
|---|---|
| Maximum | 137.40568 |
| Zeros | 35465 |
| Zeros (%) | 67.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 9.1240956 |
| 95-th percentile | 45.5831 |
| Maximum | 137.40568 |
| Range | 137.40568 |
| Interquartile range (IQR) | 9.1240956 |
Descriptive statistics
| Standard deviation | 16.070681 |
|---|---|
| Coefficient of variation (CV) | 2.2120124 |
| Kurtosis | 9.4598268 |
| Mean | 7.2651856 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.946763 |
| Sum | 348380.18 |
| Variance | 258.26677 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 35465 | |
| 55.85585327 | 103 | 0.2% |
| 56.00424194 | 94 | 0.2% |
| 70.66193848 | 52 | 0.1% |
| 70.52768555 | 47 | 0.1% |
| 55.2729187 | 47 | 0.1% |
| 55.41600342 | 40 | 0.1% |
| 70.11995239 | 40 | 0.1% |
| 55.42659912 | 35 | 0.1% |
| 69.15532227 | 32 | 0.1% |
| Other values (7695) | 11997 | 22.9% |
| (Missing) | 4461 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 35465 | |
| 1.97652874 | 1 | < 0.1% |
| 2.545617294 | 5 | < 0.1% |
| 2.574977493 | 1 | < 0.1% |
| 2.68391037 | 1 | < 0.1% |
| 2.698154259 | 2 | < 0.1% |
| 2.802563858 | 1 | < 0.1% |
| 2.827325439 | 1 | < 0.1% |
| 2.844734001 | 1 | < 0.1% |
| 2.878373146 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 137.4056763 | 6 | |
| 137.3957397 | 1 | < 0.1% |
| 134.7804304 | 1 | < 0.1% |
| 133.4128784 | 1 | < 0.1% |
| 130.2554443 | 1 | < 0.1% |
| 127.9234253 | 2 | < 0.1% |
| 125.5814575 | 1 | < 0.1% |
| 124.4825562 | 1 | < 0.1% |
| 120.9124146 | 1 | < 0.1% |
| 119.9527588 | 1 | < 0.1% |
13170_FERM0101.DO_2_PV
Categorical
CONSTANT MISSING
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 50789 |
| Missing (%) | 96.9% |
| Memory size | 2.8 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 4872 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 1624 | 3.1% |
| (Missing) | 50789 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 1624 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 3248 | |
| . | 1624 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4872 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3248 | |
| . | 1624 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4872 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3248 | |
| . | 1624 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4872 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 3248 | |
| . | 1624 |
13170_FERM0101.Gas_Overlay_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 31400 |
|---|---|
| Distinct (%) | 65.5% |
| Missing | 4461 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.6737002 |
| Minimum | 0 |
|---|---|
| Maximum | 18.399838 |
| Zeros | 16552 |
| Zeros (%) | 31.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3.9995634 |
| Q3 | 4.0001681 |
| 95-th percentile | 4.0010143 |
| Maximum | 18.399838 |
| Range | 18.399838 |
| Interquartile range (IQR) | 4.0001681 |
Descriptive statistics
| Standard deviation | 2.1302499 |
|---|---|
| Coefficient of variation (CV) | 0.79674224 |
| Kurtosis | 5.8287947 |
| Mean | 2.6737002 |
| Median Absolute Deviation (MAD) | 0.00094988447 |
| Skewness | 0.73766625 |
| Sum | 128209.27 |
| Variance | 4.5379646 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 16552 | |
| 4.000392648 | 2 | < 0.1% |
| 3.999281896 | 1 | < 0.1% |
| 4.000703796 | 1 | < 0.1% |
| 3.999554202 | 1 | < 0.1% |
| 3.999433701 | 1 | < 0.1% |
| 4.000941869 | 1 | < 0.1% |
| 3.999970251 | 1 | < 0.1% |
| 4.001452479 | 1 | < 0.1% |
| 3.999994238 | 1 | < 0.1% |
| Other values (31390) | 31390 | |
| (Missing) | 4461 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 16552 | |
| 1.590095181 | 1 | < 0.1% |
| 1.594926728 | 1 | < 0.1% |
| 1.595387055 | 1 | < 0.1% |
| 1.596584886 | 1 | < 0.1% |
| 1.597893892 | 1 | < 0.1% |
| 1.598017001 | 1 | < 0.1% |
| 1.598178277 | 1 | < 0.1% |
| 1.598417897 | 1 | < 0.1% |
| 1.598425739 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 18.39983836 | 1 | |
| 18.30288376 | 1 | |
| 16.02017071 | 1 | |
| 16.01059109 | 1 | |
| 16.00595521 | 1 | |
| 16.00560157 | 1 | |
| 16.00550007 | 1 | |
| 16.00530343 | 1 | |
| 16.00504215 | 1 | |
| 16.00489154 | 1 |
13170_FERM0101.Load_Cell_Net_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 2182 |
|---|---|
| Distinct (%) | 4.6% |
| Missing | 4460 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 829.76313 |
| Minimum | -84.4 |
|---|---|
| Maximum | 1732.4 |
| Zeros | 952 |
| Zeros (%) | 1.8% |
| Negative | 17269 |
| Negative (%) | 32.9% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -84.4 |
|---|---|
| 5-th percentile | -19.2 |
| Q1 | -17.6 |
| median | 1511.2 |
| Q3 | 1596.4 |
| 95-th percentile | 1662.8 |
| Maximum | 1732.4 |
| Range | 1816.8 |
| Interquartile range (IQR) | 1614 |
Descriptive statistics
| Standard deviation | 801.45902 |
|---|---|
| Coefficient of variation (CV) | 0.96588893 |
| Kurtosis | -1.9715843 |
| Mean | 829.76313 |
| Median Absolute Deviation (MAD) | 166.8 |
| Skewness | -0.077566454 |
| Sum | 39789631 |
| Variance | 642336.57 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -18.8 | 2718 | 5.2% |
| -18 | 2672 | 5.1% |
| -17.2 | 2610 | 5.0% |
| -19.2 | 1670 | 3.2% |
| -18.4 | 1586 | 3.0% |
| -17.6 | 1162 | 2.2% |
| -19.6 | 991 | 1.9% |
| 0 | 952 | 1.8% |
| 0.4 | 741 | 1.4% |
| 1598.8 | 711 | 1.4% |
| Other values (2172) | 32140 | |
| (Missing) | 4460 | 8.5% |
| Value | Count | Frequency (%) |
| -84.4 | 91 | |
| -84.08163405 | 1 | < 0.1% |
| -84.07962254 | 1 | < 0.1% |
| -84 | 36 | 0.1% |
| -70.4 | 1 | < 0.1% |
| -70 | 1 | < 0.1% |
| -69.77818471 | 1 | < 0.1% |
| -69.6 | 1 | < 0.1% |
| -68 | 17 | < 0.1% |
| -67.6 | 78 |
| Value | Count | Frequency (%) |
| 1732.4 | 3 | < 0.1% |
| 1732 | 1 | < 0.1% |
| 1706.24 | 1 | < 0.1% |
| 1693.85867 | 1 | < 0.1% |
| 1680.8 | 4 | < 0.1% |
| 1680.4 | 15 | |
| 1680 | 8 | < 0.1% |
| 1679.6 | 5 | < 0.1% |
| 1679.2 | 5 | < 0.1% |
| 1678.8 | 20 |
13170_FERM0101.pH_1_PV
Real number (ℝ)
MISSING
| Distinct | 6612 |
|---|---|
| Distinct (%) | 14.0% |
| Missing | 5108 |
| Missing (%) | 9.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.8343682 |
| Minimum | -1.4993618 |
|---|---|
| Maximum | 11.540951 |
| Zeros | 14 |
| Zeros (%) | < 0.1% |
| Negative | 11 |
| Negative (%) | < 0.1% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -1.4993618 |
|---|---|
| 5-th percentile | 1.3058979 |
| Q1 | 1.5838192 |
| median | 3.8540385 |
| Q3 | 5.8773048 |
| 95-th percentile | 6.0398643 |
| Maximum | 11.540951 |
| Range | 13.040313 |
| Interquartile range (IQR) | 4.2934856 |
Descriptive statistics
| Standard deviation | 2.0880752 |
|---|---|
| Coefficient of variation (CV) | 0.54456824 |
| Kurtosis | -1.8102927 |
| Mean | 3.8343682 |
| Median Absolute Deviation (MAD) | 2.0825629 |
| Skewness | -0.077898074 |
| Sum | 181384.79 |
| Variance | 4.3600579 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.305897903 | 3115 | 5.9% |
| 1.572478104 | 2033 | 3.9% |
| 1.605526733 | 1228 | 2.3% |
| 1.662327576 | 1071 | 2.0% |
| 1.421878052 | 920 | 1.8% |
| 1.627259445 | 734 | 1.4% |
| 1.598772621 | 641 | 1.2% |
| 3.585752487 | 637 | 1.2% |
| 1.550415421 | 608 | 1.2% |
| 3.515829086 | 481 | 0.9% |
| Other values (6602) | 35837 | |
| (Missing) | 5108 | 9.7% |
| Value | Count | Frequency (%) |
| -1.499361801 | 1 | < 0.1% |
| -0.2921211243 | 10 | < 0.1% |
| 0 | 14 | < 0.1% |
| 0.165086937 | 1 | < 0.1% |
| 0.2312469482 | 1 | < 0.1% |
| 1.305897903 | 3115 | |
| 1.357866669 | 63 | 0.1% |
| 1.365427143 | 1 | < 0.1% |
| 1.367677061 | 1 | < 0.1% |
| 1.370015639 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 11.54095078 | 1 | < 0.1% |
| 11.20732269 | 1 | < 0.1% |
| 10.95962372 | 3 | < 0.1% |
| 10.61732682 | 1 | < 0.1% |
| 10.40258408 | 2 | < 0.1% |
| 10.39228887 | 1 | < 0.1% |
| 10.37986679 | 17 | |
| 10.35630875 | 1 | < 0.1% |
| 9.779455566 | 4 | < 0.1% |
| 9.697975159 | 1 | < 0.1% |
13170_FERM0101.pH_2_PV
Real number (ℝ)
MISSING
| Distinct | 197 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 4460 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -23.006696 |
| Minimum | -38.210712 |
|---|---|
| Maximum | 178.7813 |
| Zeros | 26 |
| Zeros (%) | < 0.1% |
| Negative | 47253 |
| Negative (%) | 90.2% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -38.210712 |
|---|---|
| 5-th percentile | -38.210712 |
| Q1 | -38.210712 |
| median | -38.210712 |
| Q3 | -0.13858643 |
| 95-th percentile | -0.13858643 |
| Maximum | 178.7813 |
| Range | 216.99201 |
| Interquartile range (IQR) | 38.072125 |
Descriptive statistics
| Standard deviation | 18.846901 |
|---|---|
| Coefficient of variation (CV) | -0.81919199 |
| Kurtosis | -0.051468657 |
| Mean | -23.006696 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.5791745 |
| Sum | -1103240.1 |
| Variance | 355.20567 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -38.21071167 | 28873 | |
| -0.1385864258 | 16902 | |
| -0.1648593903 | 1388 | 2.6% |
| 3.329538727 | 369 | 0.7% |
| 5.159653854 | 39 | 0.1% |
| 0 | 26 | < 0.1% |
| 5.150754166 | 24 | < 0.1% |
| 5.186676025 | 22 | < 0.1% |
| 3.198595047 | 19 | < 0.1% |
| 5.19525795 | 19 | < 0.1% |
| Other values (187) | 272 | 0.5% |
| (Missing) | 4460 | 8.5% |
| Value | Count | Frequency (%) |
| -38.21071167 | 28873 | |
| -32.91919982 | 1 | < 0.1% |
| -31.54859559 | 1 | < 0.1% |
| -30.86112923 | 1 | < 0.1% |
| -30.80153819 | 1 | < 0.1% |
| -30.64641976 | 1 | < 0.1% |
| -30.61765785 | 1 | < 0.1% |
| -30.50369281 | 1 | < 0.1% |
| -30.49559705 | 1 | < 0.1% |
| -30.45100966 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 178.7812988 | 4 | |
| 178.1812988 | 1 | < 0.1% |
| 175.8241699 | 1 | < 0.1% |
| 158.660083 | 1 | < 0.1% |
| 11.98619843 | 1 | < 0.1% |
| 5.528670502 | 1 | < 0.1% |
| 5.515440458 | 1 | < 0.1% |
| 5.502289581 | 1 | < 0.1% |
| 5.500537002 | 1 | < 0.1% |
| 5.475909042 | 1 | < 0.1% |
13170_FERM0101.PUMP_1_PV
Categorical
IMBALANCE MISSING
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4461 |
| Missing (%) | 8.5% |
| Memory size | 2.8 MiB |
| 0.0 | |
|---|---|
| 48.0 | 10 |
| 37.6878392534044 | 1 |
| 10.06969766905144 | 1 |
Length
| Max length | 17 |
|---|---|
| Median length | 3 |
| Mean length | 3.0007716 |
| Min length | 3 |
Characters and Unicode
| Total characters | 143893 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 47940 | |
| 48.0 | 10 | < 0.1% |
| 37.6878392534044 | 1 | < 0.1% |
| 10.06969766905144 | 1 | < 0.1% |
| (Missing) | 4461 | 8.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 47940 | |
| 48.0 | 10 | < 0.1% |
| 37.6878392534044 | 1 | < 0.1% |
| 10.06969766905144 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 95894 | |
| . | 47952 | |
| 4 | 15 | < 0.1% |
| 8 | 12 | < 0.1% |
| 6 | 5 | < 0.1% |
| 9 | 4 | < 0.1% |
| 3 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
| 5 | 2 | < 0.1% |
| 1 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 143893 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 95894 | |
| . | 47952 | |
| 4 | 15 | < 0.1% |
| 8 | 12 | < 0.1% |
| 6 | 5 | < 0.1% |
| 9 | 4 | < 0.1% |
| 3 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
| 5 | 2 | < 0.1% |
| 1 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 143893 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 95894 | |
| . | 47952 | |
| 4 | 15 | < 0.1% |
| 8 | 12 | < 0.1% |
| 6 | 5 | < 0.1% |
| 9 | 4 | < 0.1% |
| 3 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
| 5 | 2 | < 0.1% |
| 1 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 143893 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 95894 | |
| . | 47952 | |
| 4 | 15 | < 0.1% |
| 8 | 12 | < 0.1% |
| 6 | 5 | < 0.1% |
| 9 | 4 | < 0.1% |
| 3 | 3 | < 0.1% |
| 7 | 3 | < 0.1% |
| 5 | 2 | < 0.1% |
| 1 | 2 | < 0.1% |
13170_FERM0101.PUMP_1_TOTAL
Real number (ℝ)
MISSING ZEROS
| Distinct | 174 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 4460 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.089623 |
| Minimum | 0 |
|---|---|
| Maximum | 8199.6 |
| Zeros | 2802 |
| Zeros (%) | 5.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 9.6 |
| median | 18 |
| Q3 | 34.8 |
| 95-th percentile | 58.8 |
| Maximum | 8199.6 |
| Range | 8199.6 |
| Interquartile range (IQR) | 25.2 |
Descriptive statistics
| Standard deviation | 227.28527 |
|---|---|
| Coefficient of variation (CV) | 4.2020125 |
| Kurtosis | 159.66017 |
| Mean | 54.089623 |
| Median Absolute Deviation (MAD) | 10.8 |
| Skewness | 9.2183072 |
| Sum | 2593759.7 |
| Variance | 51658.596 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40.8 | 4108 | 7.8% |
| 10.8 | 3615 | 6.9% |
| 0 | 2802 | 5.3% |
| 13.2 | 2650 | 5.1% |
| 9.6 | 2632 | 5.0% |
| 7.2 | 2309 | 4.4% |
| 34.8 | 2241 | 4.3% |
| 12 | 1863 | 3.6% |
| 20.4 | 1856 | 3.5% |
| 3.6 | 1844 | 3.5% |
| Other values (164) | 22033 | |
| (Missing) | 4460 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 2802 | |
| 0.04389663605 | 1 | < 0.1% |
| 0.06540049546 | 1 | < 0.1% |
| 0.07728355838 | 1 | < 0.1% |
| 0.08697091041 | 1 | < 0.1% |
| 0.105630452 | 1 | < 0.1% |
| 0.119300106 | 1 | < 0.1% |
| 0.121942225 | 1 | < 0.1% |
| 0.1232024746 | 1 | < 0.1% |
| 0.158445678 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 8199.6 | 2 | < 0.1% |
| 7966.627657 | 1 | < 0.1% |
| 6886.6272 | 1 | < 0.1% |
| 5806.628343 | 1 | < 0.1% |
| 4726.6272 | 1 | < 0.1% |
| 3646.628057 | 1 | < 0.1% |
| 2566.6272 | 1 | < 0.1% |
| 1486.6272 | 1 | < 0.1% |
| 1458 | 1062 | |
| 862.8282935 | 1 | < 0.1% |
13170_FERM0101.PUMP_2_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 5905 |
|---|---|
| Distinct (%) | 12.3% |
| Missing | 4461 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.53325464 |
| Minimum | 0 |
|---|---|
| Maximum | 48 |
| Zeros | 41361 |
| Zeros (%) | 78.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 4.9203722 |
| Maximum | 48 |
| Range | 48 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.7312239 |
|---|---|
| Coefficient of variation (CV) | 3.2465238 |
| Kurtosis | 67.420664 |
| Mean | 0.53325464 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.1352058 |
| Sum | 25570.626 |
| Variance | 2.9971362 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 41361 | |
| 8 | 540 | 1.0% |
| 7.609883881 | 17 | < 0.1% |
| 7.610464478 | 16 | < 0.1% |
| 2.400146484 | 15 | < 0.1% |
| 7.200439453 | 14 | < 0.1% |
| 2.399963379 | 13 | < 0.1% |
| 7.199890137 | 10 | < 0.1% |
| 4.799926758 | 10 | < 0.1% |
| 4.800292969 | 9 | < 0.1% |
| Other values (5895) | 5947 | 11.3% |
| (Missing) | 4461 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 41361 | |
| 8.509316472 × 10-5 | 1 | < 0.1% |
| 0.0005753878656 | 1 | < 0.1% |
| 0.001432784753 | 1 | < 0.1% |
| 0.001760184158 | 1 | < 0.1% |
| 0.002053044662 | 1 | < 0.1% |
| 0.0020584018 | 1 | < 0.1% |
| 0.002790056095 | 1 | < 0.1% |
| 0.002822782816 | 1 | < 0.1% |
| 0.003025307119 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 48 | 5 | < 0.1% |
| 8 | 540 | |
| 7.999996151 | 1 | < 0.1% |
| 7.999979688 | 1 | < 0.1% |
| 7.999961993 | 1 | < 0.1% |
| 7.999867251 | 1 | < 0.1% |
| 7.999805999 | 1 | < 0.1% |
| 7.999661967 | 1 | < 0.1% |
| 7.999554589 | 1 | < 0.1% |
| 7.999327633 | 1 | < 0.1% |
13170_FERM0101.PUMP_2_TOTAL
Real number (ℝ)
MISSING ZEROS
| Distinct | 8676 |
|---|---|
| Distinct (%) | 18.1% |
| Missing | 4460 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4111.4518 |
| Minimum | 0 |
|---|---|
| Maximum | 21070.669 |
| Zeros | 15718 |
| Zeros (%) | 30.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2734.1549 |
| Q3 | 7083.582 |
| 95-th percentile | 11393.57 |
| Maximum | 21070.669 |
| Range | 21070.669 |
| Interquartile range (IQR) | 7083.582 |
Descriptive statistics
| Standard deviation | 4528.4824 |
|---|---|
| Coefficient of variation (CV) | 1.1014315 |
| Kurtosis | 1.649706 |
| Mean | 4111.4518 |
| Median Absolute Deviation (MAD) | 2734.1549 |
| Skewness | 1.147215 |
| Sum | 1.9715645 × 108 |
| Variance | 20507153 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 15718 | |
| 11393.56953 | 4070 | 7.8% |
| 7083.582031 | 2198 | 4.2% |
| 7952.075 | 1332 | 2.5% |
| 5785.837891 | 1299 | 2.5% |
| 7154.80625 | 1254 | 2.4% |
| 21070.66875 | 852 | 1.6% |
| 7487.278906 | 843 | 1.6% |
| 7805.588281 | 759 | 1.4% |
| 243.3584717 | 711 | 1.4% |
| Other values (8666) | 18917 | |
| (Missing) | 4460 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 15718 | |
| 0.03316664088 | 1 | < 0.1% |
| 0.7841715813 | 1 | < 0.1% |
| 3.959999847 | 466 | 0.9% |
| 5.601608658 | 1 | < 0.1% |
| 5.755989075 | 1 | < 0.1% |
| 9.019998169 | 1 | < 0.1% |
| 10.30824051 | 1 | < 0.1% |
| 12.2329375 | 1 | < 0.1% |
| 15.32780457 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 21070.66875 | 852 | |
| 21016.14219 | 1 | < 0.1% |
| 20983.20625 | 1 | < 0.1% |
| 20973.09375 | 1 | < 0.1% |
| 20924.70156 | 1 | < 0.1% |
| 20905.75313 | 1 | < 0.1% |
| 20843.77813 | 1 | < 0.1% |
| 20823.84063 | 1 | < 0.1% |
| 20806.07188 | 1 | < 0.1% |
| 20760.79844 | 1 | < 0.1% |
13170_FERM0101.Single_Use_DO_PV
Real number (ℝ)
MISSING
| Distinct | 10524 |
|---|---|
| Distinct (%) | 21.9% |
| Missing | 4461 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 586.63223 |
| Minimum | 0 |
|---|---|
| Maximum | 905.0707 |
| Zeros | 27 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 15.454408 |
| Q1 | 663.8938 |
| median | 715.94063 |
| Q3 | 799.99199 |
| 95-th percentile | 799.99199 |
| Maximum | 905.0707 |
| Range | 905.0707 |
| Interquartile range (IQR) | 136.09819 |
Descriptive statistics
| Standard deviation | 308.61539 |
|---|---|
| Coefficient of variation (CV) | 0.52607984 |
| Kurtosis | -0.4365981 |
| Mean | 586.63223 |
| Median Absolute Deviation (MAD) | 84.051367 |
| Skewness | -1.1871057 |
| Sum | 28130189 |
| Variance | 95243.46 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 799.9919922 | 18339 | |
| 703.9084473 | 4072 | 7.8% |
| 715.940625 | 2031 | 3.9% |
| 667.1603516 | 1934 | 3.7% |
| 691.7952637 | 1233 | 2.4% |
| 663.8937988 | 869 | 1.7% |
| 766.2758301 | 793 | 1.5% |
| 719.4172852 | 769 | 1.5% |
| 709.4014648 | 670 | 1.3% |
| 905.0707031 | 607 | 1.2% |
| Other values (10514) | 16635 | |
| (Missing) | 4461 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 27 | |
| 0.9407118821 | 1 | < 0.1% |
| 0.9930820276 | 1 | < 0.1% |
| 1.008743496 | 1 | < 0.1% |
| 1.012209416 | 1 | < 0.1% |
| 1.092278305 | 1 | < 0.1% |
| 1.176531131 | 1 | < 0.1% |
| 1.188285434 | 1 | < 0.1% |
| 1.195094785 | 1 | < 0.1% |
| 1.217081385 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 905.0707031 | 607 | 1.2% |
| 898.8673828 | 95 | 0.2% |
| 883.7032722 | 1 | < 0.1% |
| 869.6510742 | 31 | 0.1% |
| 799.9919922 | 18339 | |
| 797.8545018 | 1 | < 0.1% |
| 786.2329102 | 17 | < 0.1% |
| 784.1854526 | 1 | < 0.1% |
| 770.4497362 | 1 | < 0.1% |
| 766.2758301 | 793 | 1.5% |
13170_FERM0101.Single_Use_pH_PV
Real number (ℝ)
MISSING
| Distinct | 2032 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 4461 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 623.76427 |
| Minimum | -0.4 |
|---|---|
| Maximum | 805.76797 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 21 |
| Negative (%) | < 0.1% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -0.4 |
|---|---|
| 5-th percentile | 5.8 |
| Q1 | 799.68799 |
| median | 799.87197 |
| Q3 | 799.97598 |
| 95-th percentile | 800.048 |
| Maximum | 805.76797 |
| Range | 806.16797 |
| Interquartile range (IQR) | 0.28798828 |
Descriptive statistics
| Standard deviation | 330.01841 |
|---|---|
| Coefficient of variation (CV) | 0.52907552 |
| Kurtosis | -0.20757163 |
| Mean | 623.76427 |
| Median Absolute Deviation (MAD) | 0.15200195 |
| Skewness | -1.3388099 |
| Sum | 29910744 |
| Variance | 108912.15 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 800.0239746 | 4454 | 8.5% |
| 799.8959961 | 3982 | 7.6% |
| 799.8160156 | 3136 | 6.0% |
| 800.0319824 | 2215 | 4.2% |
| 799.8560059 | 1817 | 3.5% |
| 799.7199707 | 1807 | 3.4% |
| 800.0399902 | 1585 | 3.0% |
| 799.9120117 | 1410 | 2.7% |
| 799.8399902 | 1349 | 2.6% |
| 799.952002 | 1338 | 2.6% |
| Other values (2022) | 24859 | |
| (Missing) | 4461 | 8.5% |
| Value | Count | Frequency (%) |
| -0.4 | 1 | < 0.1% |
| -0.1919998169 | 1 | < 0.1% |
| -0.1759998322 | 3 | |
| -0.1520000458 | 1 | < 0.1% |
| -0.1439998627 | 1 | < 0.1% |
| -0.136000061 | 3 | |
| -0.1040000916 | 1 | < 0.1% |
| -0.09599990845 | 1 | < 0.1% |
| -0.07999992371 | 4 | |
| -0.07200012207 | 2 |
| Value | Count | Frequency (%) |
| 805.7679688 | 469 | 0.9% |
| 800.1359863 | 266 | 0.5% |
| 800.1040039 | 617 | 1.2% |
| 800.0719727 | 461 | 0.9% |
| 800.047998 | 1114 | 2.1% |
| 800.0399902 | 1585 | 3.0% |
| 800.0319824 | 2215 | |
| 800.0239746 | 4454 | |
| 800 | 362 | 0.7% |
| 799.9919922 | 364 | 0.7% |
13170_FERM0101.Temperatura_PV
Real number (ℝ)
MISSING
| Distinct | 23846 |
|---|---|
| Distinct (%) | 49.7% |
| Missing | 4461 |
| Missing (%) | 8.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.41517 |
| Minimum | -0.4 |
|---|---|
| Maximum | 81.073239 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -0.4 |
|---|---|
| 5-th percentile | 3.1840027 |
| Q1 | 12.856006 |
| median | 16.112 |
| Q3 | 29.551464 |
| 95-th percentile | 29.631995 |
| Maximum | 81.073239 |
| Range | 81.473239 |
| Interquartile range (IQR) | 16.695458 |
Descriptive statistics
| Standard deviation | 9.1533596 |
|---|---|
| Coefficient of variation (CV) | 0.52559691 |
| Kurtosis | -1.0092319 |
| Mean | 17.41517 |
| Median Absolute Deviation (MAD) | 7.2079956 |
| Skewness | -0.027527222 |
| Sum | 835092.24 |
| Variance | 83.783993 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 29.6 | 2139 | 4.1% |
| 29.60799561 | 1900 | 3.6% |
| 29.57600098 | 1339 | 2.6% |
| 3.208001709 | 1244 | 2.4% |
| 29.63199463 | 1142 | 2.2% |
| 3.184002686 | 987 | 1.9% |
| 3.223999023 | 838 | 1.6% |
| 29.55999756 | 553 | 1.1% |
| 3.176000977 | 508 | 1.0% |
| 29.64000244 | 432 | 0.8% |
| Other values (23836) | 36870 | |
| (Missing) | 4461 | 8.5% |
| Value | Count | Frequency (%) |
| -0.4 | 1 | < 0.1% |
| 3.023999023 | 1 | < 0.1% |
| 3.047998047 | 3 | < 0.1% |
| 3.064001465 | 1 | < 0.1% |
| 3.064208646 | 1 | < 0.1% |
| 3.073570447 | 1 | < 0.1% |
| 3.073635563 | 1 | < 0.1% |
| 3.079998779 | 8 | |
| 3.096002197 | 8 | |
| 3.103990935 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 81.07323879 | 1 | |
| 80.56978423 | 1 | |
| 32.43199463 | 1 | |
| 32.42562641 | 1 | |
| 32.41154145 | 1 | |
| 32.34565196 | 1 | |
| 32.34399414 | 1 | |
| 32.32800293 | 1 | |
| 32.20336209 | 1 | |
| 32.09599609 | 1 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| 13170_FERM0101.Agitation_PV | 13170_FERM0101.Air_Sparge_PV | 13170_FERM0101.Biocontainer_Pressure_PV | 13170_FERM0101.DO_1_PV | 13170_FERM0101.DO_2_PV | 13170_FERM0101.Gas_Overlay_PV | 13170_FERM0101.Load_Cell_Net_PV | 13170_FERM0101.pH_1_PV | 13170_FERM0101.pH_2_PV | 13170_FERM0101.PUMP_1_PV | 13170_FERM0101.PUMP_1_TOTAL | 13170_FERM0101.PUMP_2_PV | 13170_FERM0101.PUMP_2_TOTAL | 13170_FERM0101.Single_Use_DO_PV | 13170_FERM0101.Single_Use_pH_PV | 13170_FERM0101.Temperatura_PV | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DateTime | ||||||||||||||||
| 2023-03-15 00:00:00.000 | 80.0 | 0.0 | 0.269098 | 0.0 | NaN | 3.999282 | 1563.6 | 5.905050 | -0.138586 | 0.0 | 6.0 | 0.0 | 149.229419 | 799.991992 | 799.83999 | 29.600000 |
| 2023-03-15 00:15:00.000 | 80.0 | 0.0 | -0.054985 | 0.0 | NaN | 4.000669 | 1563.6 | 5.905050 | -0.138586 | 0.0 | 6.0 | 0.0 | 149.229419 | 799.991992 | 799.83999 | 29.559998 |
| 2023-03-15 00:30:00.000 | 80.0 | 0.0 | 0.188080 | 0.0 | NaN | 4.000764 | 1563.6 | 5.905050 | -0.138586 | 0.0 | 6.0 | 0.0 | 149.229419 | 799.991992 | 799.83999 | 29.600000 |
| 2023-03-15 00:45:00.000 | 80.0 | 0.0 | -0.075177 | 0.0 | NaN | 3.999647 | 1563.6 | 5.905050 | -0.138586 | 0.0 | 6.0 | 0.0 | 149.229419 | 799.991992 | 799.83999 | 29.599935 |
| 2023-03-15 01:00:00.000 | 80.0 | 0.0 | -0.014465 | 0.0 | NaN | 3.999329 | 1563.6 | 5.905050 | -0.138586 | 0.0 | 6.0 | 0.0 | 149.229419 | 799.991992 | 799.83999 | 29.576001 |
| 2023-03-15 01:15:00.000 | 80.0 | 0.0 | -0.054150 | 0.0 | NaN | 3.999083 | 1563.6 | 5.905050 | -0.138586 | 0.0 | 6.0 | 0.0 | 149.229419 | 799.991992 | 799.83999 | 29.560331 |
| 2023-03-15 01:30:00.000 | 80.0 | 0.0 | 0.026044 | 0.0 | NaN | 4.000356 | 1563.6 | 5.905202 | -0.138586 | 0.0 | 6.0 | 0.0 | 149.229419 | 799.991992 | 799.83999 | 29.576001 |
| 2023-03-15 01:45:00.000 | 80.0 | 0.0 | -0.013920 | 0.0 | NaN | 4.000333 | 1563.6 | 5.913279 | -0.138586 | 0.0 | 6.0 | 0.0 | 149.229419 | 799.991992 | 799.83999 | 29.607996 |
| 2023-03-15 02:00:00.000 | 80.0 | 0.0 | -0.015107 | 0.0 | NaN | 3.999709 | 1563.6 | 5.913279 | -0.138586 | 0.0 | 6.0 | 0.0 | 149.229419 | 799.991992 | 799.83999 | 29.600084 |
| 2023-03-15 02:15:00.000 | 80.0 | 0.0 | 0.025316 | 0.0 | NaN | 4.000142 | 1563.6 | 5.913279 | -0.138586 | 0.0 | 6.0 | 0.0 | 149.229419 | 799.991992 | 799.83999 | 29.607996 |
| 13170_FERM0101.Agitation_PV | 13170_FERM0101.Air_Sparge_PV | 13170_FERM0101.Biocontainer_Pressure_PV | 13170_FERM0101.DO_1_PV | 13170_FERM0101.DO_2_PV | 13170_FERM0101.Gas_Overlay_PV | 13170_FERM0101.Load_Cell_Net_PV | 13170_FERM0101.pH_1_PV | 13170_FERM0101.pH_2_PV | 13170_FERM0101.PUMP_1_PV | 13170_FERM0101.PUMP_1_TOTAL | 13170_FERM0101.PUMP_2_PV | 13170_FERM0101.PUMP_2_TOTAL | 13170_FERM0101.Single_Use_DO_PV | 13170_FERM0101.Single_Use_pH_PV | 13170_FERM0101.Temperatura_PV | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DateTime | ||||||||||||||||
| 2024-09-10 21:45:00.000 | 80.0 | 0.000000 | 0.844378 | 18.646805 | 0.0 | 3.999450 | 1663.6 | 5.878986 | -0.164859 | 0.0 | 32.4 | 1.821689 | 1433.873633 | 18.494623 | 5.936000 | 29.605602 |
| 2024-09-10 22:00:00.000 | 80.0 | 0.000000 | 0.812403 | 26.247729 | 0.0 | 4.000085 | 1663.6 | 5.878986 | -0.164859 | 0.0 | 32.4 | 1.655831 | 1474.316992 | 26.998062 | 5.936000 | 29.607996 |
| 2024-09-10 22:15:00.000 | 80.0 | 39.491501 | 1.212550 | 13.439920 | 0.0 | 3.999780 | 1663.6 | 5.878986 | -0.164859 | 0.0 | 32.4 | 1.611375 | 1508.082227 | 14.446572 | 5.930321 | 29.593037 |
| 2024-09-10 22:30:00.000 | 80.0 | 46.381168 | 1.666669 | 13.950053 | 0.0 | 3.999735 | 1663.6 | 5.878986 | -0.164859 | 0.0 | 32.4 | 1.395057 | 1542.336133 | 15.540279 | 5.912000 | 29.607996 |
| 2024-09-10 22:45:00.000 | 80.0 | 52.892578 | 1.909723 | 14.781247 | 0.0 | 4.001943 | 1663.6 | 5.878986 | -0.164859 | 0.0 | 32.4 | 1.367089 | 1576.052148 | 17.359422 | 5.936000 | 29.600000 |
| 2024-09-10 23:00:00.000 | 80.0 | 0.000000 | 0.741613 | 16.673283 | 0.0 | 4.000484 | 1663.6 | 5.878986 | -0.164859 | 0.0 | 32.4 | 0.867622 | 1612.669336 | 16.069099 | 5.936000 | 29.607996 |
| 2024-09-10 23:15:00.000 | 80.0 | 2.521371 | 0.828348 | 15.472241 | 0.0 | 4.001014 | 1663.6 | 5.878986 | -0.164859 | 0.0 | 32.4 | 0.396070 | 1649.857812 | 14.757623 | 5.936000 | 29.600000 |
| 2024-09-10 23:30:00.000 | 80.0 | 0.000000 | 0.716165 | 21.826375 | 0.0 | 4.001632 | 1663.6 | 5.878986 | -0.164859 | 0.0 | 32.4 | 0.549096 | 1685.930469 | 21.647653 | 5.944000 | 29.600000 |
| 2024-09-10 23:45:00.000 | 80.0 | 48.277886 | 1.541633 | 12.983664 | 0.0 | 4.000685 | 1664.0 | 5.878986 | -0.164859 | 0.0 | 32.4 | 0.464247 | 1723.688672 | 14.295586 | 5.941581 | 29.600000 |
| 2024-09-11 00:00:00.000 | 80.0 | 64.313885 | 2.397993 | 14.085248 | 0.0 | 4.003011 | 1664.0 | 5.878986 | -0.164859 | 0.0 | 32.4 | 0.971887 | 1756.806641 | 16.894058 | 5.944000 | 29.602386 |
Most frequently occurring
| 13170_FERM0101.Agitation_PV | 13170_FERM0101.Air_Sparge_PV | 13170_FERM0101.Biocontainer_Pressure_PV | 13170_FERM0101.DO_1_PV | 13170_FERM0101.DO_2_PV | 13170_FERM0101.Gas_Overlay_PV | 13170_FERM0101.Load_Cell_Net_PV | 13170_FERM0101.pH_1_PV | 13170_FERM0101.pH_2_PV | 13170_FERM0101.PUMP_1_PV | 13170_FERM0101.PUMP_1_TOTAL | 13170_FERM0101.PUMP_2_PV | 13170_FERM0101.PUMP_2_TOTAL | 13170_FERM0101.Single_Use_DO_PV | 13170_FERM0101.Single_Use_pH_PV | 13170_FERM0101.Temperatura_PV | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1154 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4460 |
| 346 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -18.8 | 1.421878 | -0.164859 | 0.0 | 40.8 | 0.0 | 11393.569531 | 703.908447 | 800.023975 | 14.223999 | 13 |
| 267 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -19.2 | 1.305898 | -38.210712 | 0.0 | 40.8 | 0.0 | 11393.569531 | 703.908447 | 800.023975 | 14.576001 | 12 |
| 362 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -18.8 | 1.421878 | -0.164859 | 0.0 | 40.8 | 0.0 | 11393.569531 | 703.908447 | 800.023975 | 14.480005 | 11 |
| 932 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -17.2 | 1.572478 | -38.210712 | 0.0 | 34.8 | 0.0 | 7083.582031 | 715.940625 | 799.895996 | 14.695996 | 11 |
| 941 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -17.2 | 1.572478 | -38.210712 | 0.0 | 34.8 | 0.0 | 7083.582031 | 715.940625 | 799.895996 | 14.831995 | 11 |
| 980 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -17.2 | 1.572478 | -38.210712 | 0.0 | 34.8 | 0.0 | 7083.582031 | 715.940625 | 799.895996 | 15.456006 | 11 |
| 313 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -18.8 | 1.305898 | -38.210712 | 0.0 | 40.8 | 0.0 | 11393.569531 | 703.908447 | 800.023975 | 14.704004 | 10 |
| 946 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -17.2 | 1.572478 | -38.210712 | 0.0 | 34.8 | 0.0 | 7083.582031 | 715.940625 | 799.895996 | 14.935999 | 10 |
| 967 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -17.2 | 1.572478 | -38.210712 | 0.0 | 34.8 | 0.0 | 7083.582031 | 715.940625 | 799.895996 | 15.264001 | 10 |